SWISSGRID DATA ANALYSIS + ELECTRICITY MARKET PLOTS

This is an R Markdown Notebook. When you execute code within the notebook, the results appear beneath the code.

Try executing this chunk by clicking the Run button within the chunk or by placing your cursor inside it and pressing Ctrl+Shift+Enter.

Prepare project

p_load(blogdown)

Installing package into 㤼㸱C:/GIT_clones/BAFU_Strompreise/local_package_library/3.5.1㤼㸲
(as 㤼㸱lib㤼㸲 is unspecified)
cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/src/contrib/PACKAGES.rds': HTTP status was '404 Not Found'also installing the dependencies 㤼㸱bookdown㤼㸲, 㤼㸱servr㤼㸲

cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5/PACKAGES.rds': HTTP status was '404 Not Found'cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5/PACKAGES.gz': HTTP status was '404 Not Found'cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5/PACKAGES': HTTP status was '404 Not Found'unable to access index for repository http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5:
  cannot open URL 'http://www.stats.ox.ac.uk/pub/RWin/bin/windows/contrib/3.5/PACKAGES'trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.5/bookdown_0.7.zip'
Content type 'application/zip' length 928178 bytes (906 KB)
downloaded 906 KB

trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.5/servr_0.10.zip'
Content type 'application/zip' length 86343 bytes (84 KB)
downloaded 84 KB

trying URL 'https://cran.rstudio.com/bin/windows/contrib/3.5/blogdown_0.8.zip'
Content type 'application/zip' length 155287 bytes (151 KB)
downloaded 151 KB

package ‘bookdown’ successfully unpacked and MD5 sums checked
package ‘servr’ successfully unpacked and MD5 sums checked
package ‘blogdown’ successfully unpacked and MD5 sums checked

The downloaded binary packages are in
    C:\Users\tes\AppData\Local\Temp\Rtmp8WWWS9\downloaded_packages

blogdown installed

Data preparation

Plotting Section

##' === === === === === === === === === === === === === === === === ====
##' 
##' # INIT ALL PLOTS (run first)  ####
##' 
##' === === === === === === === === === === === === === === === === ===
SaveOutput <- T
YvalueRange <- c(0,6000)
addRangeSel <- F
Lang <- "DE"
# Defining Hash tables for storing the different plots, data, and strings for different language options
FileNames <- hash::hash()
PlotTitle <- hash::hash()
XAxisTitle <- hash::hash()
YAxisTitle <- hash::hash()
Year <- "2010/2018"
Years <- c(as.character(c(2010:2018)))
# Years <- c(as.character(c(2010:2018)),"2010/2018")
# Screen Width & Height for single screen
scr_width <- system("wmic desktopmonitor get screenwidth", intern=TRUE)[2] %>% as.numeric(.)
scr_height <- system("wmic desktopmonitor get screenheight", intern=TRUE)[2] %>% as.numeric(.)

Plot (dygraphs) original Swissgrid Data

##' === === === === === === === === === === === === === === === === ===
##' 
##' .. 15min Swissgrid Data Interactive ####
##' 
##' === === === === === === === === === === === === === === === === ===
##' Save Interactive DyGraph Plot
##' Knitr und RMarkdown um eine HTML zu erzeugen
SG.plots <- hash::hash()
ElDat.Plots <- hash::hash()
With2ndAxis <- F
# SecondAxisOption: 
# 1: Consumption
# 2: Prices
SecondAxisOption <- 2
WithGrouping <- F
Grouping <- "G1"
for (Year in Years) {
  PlotData <- ElDat_with_Prices
  
  # Define Plot Titles in diffrent languages.
  # If variable Year is something similar to "2010/2016" gsub converts it to "2010 to 2016" in the title.
  PlotTitle["DE"] <- enc2utf8(paste("Elektrizitäts Profil der Schweiz ",
                                      gsub(pattern="/", x=Year,replacement=" bis ")))
  PlotTitle["EN"] <- enc2utf8(paste("Swiss Electricity Profiles ",
                                      gsub(pattern="/", x=Year,replacement=" to ")))
  
  # Define file names for each plot in variable Years with which the plot will be saved on disk.
  # Includes language dependencies.
  FileName <- file.path(getwd(),
                        "figures",
                        paste0(Lang,"_SG_Data_",
                               gsub(pattern="/", x=Year,replacement="_"), # needed if filter is e.g. "2010/2016"
                               ifelse(With2ndAxis,"_2ndAxis",""),
                               ".html"))
  # source files to plot the dygraphs of electricity profiles
  source("scripts/plot_ElectricityDat.R",encoding = "UTF-8")
  dyg <- 
    dyg %>%   
    dyOptions(stackedGraph=T,stepPlot=T,drawGapEdgePoints = F,
              useDataTimezone=T,fillGraph = F,fillAlpha = 0.85,drawPoints = F)
  if (addRangeSel) {source("scripts/plot_ElectricityDat_addRangeSelector.R",encoding = "UTF-8")} 
  
  # Saving the plots individually in a hash file.
  # They can be 
  SG.plots[Year] <- dyg
  print(dyg)
  
  # For standard export procedure
  ElDat.Plots[Year] <- dyg
  FileNames[Year] <- FileName
}

if (SaveOutput) {
  for (Year in Years) {
    saveWidget(ElDat.Plots[[Year]], FileNames[[Year]], 
               selfcontained = TRUE, libdir = NULL,
               background = "white", knitrOptions = list())
    
    webshot(FileNames[[Year]], file = paste0(FileNames[[Year]],".png"),
            cliprect = "viewport",
            expand = c(-100, 200, 200, -100), #top, right, bottom, left
            # selector = "canvas",
            vwidth = scr_width,
            vheight = scr_height,
            # zoom=2.5,
            eval = "casper.then(function() {
            casper.zoom(4)
  });"
              )
  }
}

Add a new chunk by clicking the Insert Chunk button on the toolbar or by pressing Ctrl+Alt+I.

When you save the notebook, an HTML file containing the code and output will be saved alongside it (click the Preview button or press Ctrl+Shift+K to preview the HTML file).

The preview shows you a rendered HTML copy of the contents of the editor. Consequently, unlike Knit, Preview does not run any R code chunks. Instead, the output of the chunk when it was last run in the editor is displayed.